SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195497 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195497 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28018,633190,90502,583289,66681,140785,411565,217587,392498,446426,866678,277544,694695,538739,107386,762895,1040612,927925,333687,526538,401234,1010656,427445,738048,134612,345384,253789,646948,653048,854544,921200,794774,467805,59873,567570,1042718,551100,925937,504159,326162,424247,218356,895361,527767,705385,625548,74475,485579,940759,594175,937607,1029426,417944,46613,618399,784519,350278,1011390,606743,1476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195497 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195497 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]