SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003995s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287800 LIMIT 1 [ RunTime:0.002062s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287800 [ RunTime:0.009423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771193,560775,1039019,401812,569144,554347,553092,631282,527957,927006,148658,19504,827446,965440,1018597,393330,44352,941328,79053,517938,918890,695981,199237,458358,336456,314880,65051,909270,302541,314157,1014834,531275,165998,68334,297193,175092,308050,98253,489878,127616,921574,527804,851711,265074,770504,675816,9900,367691,310452,355058,130459,610675,605321,1009366,322711,841991,666664,154629,184605,173610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004250s ]