SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242680 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242680 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039362,993682,91414,471895,357807,488281,774950,850539,821666,594827,48127,390792,816694,926071,203060,104673,400114,707385,171936,434457,326332,39836,107038,965527,807291,662207,461798,270170,705882,106054,524647,623815,133269,839213,116549,755688,884989,1002998,822932,168604,694102,801667,290448,323386,887429,459822,642861,251774,639505,503566,565543,74303,920303,573152,493020,5745,737720,648098,117696,872556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001123s ]