SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537593 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537593 [ RunTime:0.002308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536173,526984,884591,1000437,463641,373286,983606,482442,571193,221264,204074,114413,462438,884379,938,232176,205880,924218,927445,800155,901319,179999,782464,355066,463504,104683,265899,245465,670,80058,832277,506120,478273,386081,269801,735408,961736,304868,241386,529633,928497,275776,7736,204861,283642,650602,109949,86139,31132,220312,53852,426409,993097,633154,162708,166442,340406,669500,98841,856375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]