SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281533 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281533 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520261,614858,106456,254401,786220,341120,496405,198827,949875,845036,179037,255342,298787,372923,278692,245711,1042469,687847,816800,932726,842311,919605,325261,1043319,719256,439355,505935,750806,849264,746168,634977,220265,633058,1011352,532871,713601,318027,954960,350936,625390,49776,859605,548833,487215,379164,589626,761589,224105,559566,555449,747831,106379,433773,759945,676880,960027,46658,768989,292958,271989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002079s ]