SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106410 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106410 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046646,931060,1035400,921115,711802,984419,701200,835695,964540,958804,336733,400531,202666,891566,614154,970357,374946,470397,869215,693460,471589,547400,83998,16644,382944,113660,1048350,559066,154578,850749,803783,342392,486578,194875,340175,785065,749297,136665,601693,262357,255631,866661,815026,1038032,273144,745061,105485,62620,918386,132496,417361,225594,602485,298689,958880,843783,303300,443417,395944,860792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]