SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984029 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984029 [ RunTime:0.003426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327517,883653,378053,133986,384232,965740,938230,1000608,820921,988329,1032728,342109,96779,685534,145492,946662,543496,1030368,590340,2349,672172,575455,596467,1009921,167248,484179,186933,926722,764890,250459,790059,781238,24880,418168,748148,418628,549143,437897,749752,646805,67642,313359,564828,251473,570899,262800,168588,355118,423810,587478,808852,822446,535154,834454,777181,716718,756850,622843,148073,791102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]