SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316396 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316396 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343878,711125,425345,959751,559232,198680,984822,388148,712165,828793,1022676,106481,687813,715058,225597,936166,126505,525525,704523,548903,157975,188738,39383,472889,683520,259222,849256,542161,77935,553995,498039,547845,540199,226441,755287,366658,185139,101690,918811,49825,850143,744844,558211,52295,300846,70220,46944,768634,732265,925909,553660,205985,110736,88086,428404,652654,328479,126232,419643,263428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]