SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144328 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144328 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803516,732376,402432,961016,1044539,332700,548904,75568,367824,638882,413867,579442,984382,44635,377326,512245,729952,1033627,33650,1017597,1010932,314622,1037952,404644,158496,401221,383236,200533,546207,619740,235581,442940,278982,231645,916348,160954,500739,403407,816261,237372,753069,455796,149603,219534,979959,4106,950531,743554,336995,384211,786757,134737,914722,856155,101282,182931,642317,363881,208185,980433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]