SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002394 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002394 [ RunTime:0.004181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877502,111699,805993,843366,151579,903267,1001020,585797,386878,931344,377750,1018699,1030092,29841,20055,544243,575402,538492,1035964,601254,779646,1012456,484968,505331,91988,372131,256306,219016,45281,542551,716305,831265,270185,43006,851916,838082,825794,534922,185420,466837,743747,251001,660595,522845,777351,509600,133051,55124,1019333,412615,999799,402538,81242,510986,778778,631370,668012,606141,875842,124474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]