SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512813 LIMIT 1 [ RunTime:0.000624s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512813 [ RunTime:0.004666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006875,622157,633946,788710,977615,273750,227385,8187,924991,336090,280024,360233,812673,884790,689265,888282,998586,794846,754121,18213,120607,529787,146294,622031,203084,857485,95064,963493,994170,827970,1036765,491501,1022716,318789,283289,1002832,163339,163483,613560,756533,850477,178826,403298,143544,597066,1040167,662850,88920,149101,583349,557620,232359,901004,798182,637365,852074,1003017,662533,736362,639616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000980s ]