SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199831 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199831 [ RunTime:0.003632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678581,32930,748407,741625,551537,601662,1007640,448684,863281,178984,857026,459420,155776,778675,659919,106044,266228,42055,990998,409942,858557,1025448,785706,932837,587256,564438,669545,280949,234510,944122,1023535,507876,492936,561053,921823,685371,985398,993541,25026,269525,1047922,992720,757559,396285,461977,239331,631683,461613,520962,135325,32262,530624,24727,698053,410563,250748,338154,90262,125852,330735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]