SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535988 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535988 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497044,945179,168098,975552,200690,935144,243789,79506,1027586,701672,175647,410119,143710,999176,341127,674978,404591,714657,940109,482602,67658,767152,1002567,581664,846480,36415,93570,223406,799885,930551,1041982,1016989,28580,281484,284415,83358,987062,438121,762693,910436,822437,349088,910683,697694,872578,492218,952700,639320,56457,1016684,349017,697620,620571,637002,697656,505126,194876,1026495,802186,526608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]