SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3009 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3009 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158096,844551,659998,52403,537673,100679,112948,237224,166001,828358,674013,732914,473689,355856,880631,533352,201560,350636,644338,949142,512511,738279,17042,408511,454669,59489,223320,589146,560532,579085,321738,929531,73981,597591,763570,184739,775013,682724,738757,974009,262998,706316,990129,430601,169566,479446,140186,968038,267780,918366,114746,938502,388176,168540,456141,986047,320806,153492,663831,606427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]