SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343838 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343838 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675184,372652,924328,683704,204733,815546,287951,237937,967393,771025,906929,291520,786234,140703,846054,1015451,423514,659002,138323,75964,124441,853441,1000040,601097,195593,722528,956963,303687,1007894,354269,612294,385606,189443,579760,603780,342817,912133,447148,433389,38244,800762,984295,952091,894090,351244,503631,798831,936600,618885,392761,908104,349777,354439,340888,495257,714525,88736,292343,578020,1005514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]