SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006749s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402387 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402387 [ RunTime:0.002950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744943,183198,390376,989449,519028,300711,483834,389328,860524,657619,983092,394547,64674,421406,91851,715983,784736,712089,797911,859787,733441,304761,749232,252670,1029924,630136,339378,402285,223236,811256,152,1021333,25886,649726,857975,158327,905130,349880,989939,198705,187503,271682,424582,978692,708623,704306,813627,869802,582716,481889,658715,182141,124265,980435,848164,191646,187511,349066,784425,808058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402387 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402387 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]