SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004650s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312581 LIMIT 1 [ RunTime:0.003408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312581 [ RunTime:0.005520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180190,1026706,847367,213760,298619,643019,211336,775316,53739,897376,196534,886955,941198,913876,885833,977562,417344,437913,581330,397999,954847,755732,532931,28671,1018323,1012582,770702,996461,247713,732282,882457,311168,934375,231343,919025,490364,94684,391855,477736,709783,165018,137495,15501,674583,855417,522270,725273,122828,353609,305391,673065,718389,255821,171211,729327,154149,475229,275262,673090,58866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]