SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547196 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547196 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635440,1004893,63916,540264,302095,470494,62817,666391,989299,264774,671872,174354,220395,182656,925130,743965,244366,669328,282608,446810,539421,98098,945824,1004119,287318,375183,809436,612221,554647,943706,70622,988208,1009706,1032639,850165,596737,413576,834155,895414,720824,5005,661148,952375,811735,682786,842724,288139,1028762,311349,1019950,69272,49249,877842,338234,87300,991037,851794,922243,200524,824415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]