SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464196 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464196 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754807,903453,640521,777104,15396,478860,436059,995637,890639,528366,572822,887027,87511,587071,102356,941416,1027031,819583,639846,738290,962434,835563,838279,937544,120776,227563,405022,359064,553277,177416,944891,150339,104507,348314,373467,774112,112854,540397,563030,909844,432709,437929,209132,604843,892766,100974,347882,1008777,118320,77747,1005444,125245,317269,782396,462317,940958,52299,839683,271449,953067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]