SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315401 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315401 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444291,165206,779424,746765,370779,531080,116179,820387,100152,901349,721689,789233,83123,54653,645295,763783,785607,1037038,678051,736062,123023,373049,265376,648914,83893,375615,539426,155560,566427,167536,272812,33993,736760,428260,450131,1014052,915627,641176,1013001,685322,863664,829228,331115,803915,142847,103149,823764,688816,483929,39496,107167,737524,1007696,893693,509066,856783,465662,855263,149633,525675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]