SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112650 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112650 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042378,914682,777542,161315,877463,141713,1004125,36961,38612,325255,607068,730430,747589,624663,60970,241633,1039738,82333,115816,367702,795,439888,543417,230166,332813,233419,720096,103441,183106,241610,745940,165814,328379,365761,936843,928082,745074,604087,189903,301988,486370,51265,1000682,1016915,628621,76158,233497,49878,163364,242001,741193,694051,488464,462665,331950,444047,692795,136643,181281,814000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]