SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41729 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41729 [ RunTime:0.003056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833064,810089,636021,856884,596099,890408,295582,239028,1004687,942769,42917,216650,162145,335731,56534,117113,432764,434365,255391,186351,437256,694443,1011026,97300,437601,128627,76582,420597,854693,287342,712273,444901,307901,638580,88700,7225,466386,1030253,246726,799097,437774,759941,119792,780073,950090,1845,750183,413941,762947,272956,171702,926463,447747,189308,542694,1039120,973547,596518,88818,381147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]