SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593969 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593969 [ RunTime:0.006639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494870,813521,55067,446835,394356,132317,742577,264893,286098,730586,772915,10672,545509,87940,270148,714810,44112,1017295,883965,937514,823366,703170,775359,967632,796272,719824,362622,286600,226549,789046,999486,390192,382667,1017068,113316,650125,74805,426761,898137,1000833,247942,694986,266145,508879,1019164,830025,765771,224745,52442,385317,563610,629529,394425,621720,967076,314927,670036,279640,623650,856827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]