SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40252 LIMIT 1 [ RunTime:0.000648s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40252 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910860,626159,779319,883347,594793,842227,751291,78150,653247,795847,135050,885488,39959,80458,1003186,804828,108938,488986,345676,226787,1014691,17201,618380,873513,654724,1015548,726867,475063,701150,533480,109589,253705,727888,295350,517278,887781,793364,489299,232923,490133,167487,555290,32189,393927,544950,229174,416625,247818,890677,695277,578636,1007783,337235,734242,192895,918692,3950,441513,257104,739112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]