SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804982 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804982 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711604,275553,1002141,333576,23837,918248,285742,700554,791772,556323,541640,275214,422600,416073,688800,65798,488820,555710,399796,661000,213952,148215,790109,1047748,1006871,116289,224566,53049,482084,774884,524040,221436,1009484,932023,677629,461060,303937,645368,254120,82201,534793,334031,667706,589496,853351,945600,755466,817688,92730,962124,1023143,712800,318519,831549,976851,358167,1026932,984760,617480,969617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]