SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986185 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986185 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937616,548836,298207,808604,220514,1009856,108746,155089,305064,890779,844253,744203,144412,873069,974088,509762,453519,397892,753700,563543,958441,683394,67877,391322,715554,383633,123200,268514,242599,12639,36156,301268,391510,436814,317121,27748,941693,994746,6048,270834,146241,160155,984605,1029172,380992,188564,1008683,1003101,849687,988594,68103,845148,275383,193713,755990,364101,707887,464785,1007828,419491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]