SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002863s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442106 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442106 [ RunTime:0.004172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406564,610913,99936,545113,669699,568174,353626,1020958,142377,363369,189946,896833,664055,814850,241473,292586,465825,311440,718400,131485,253837,945778,500668,52866,640787,518391,336402,311353,757052,465287,218033,37494,345654,307872,793230,833015,918944,880800,186812,318061,213335,415181,625806,426933,541831,694118,605070,583688,832193,643339,657107,202604,1006334,269729,99634,593234,677858,401557,508237,328219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]