SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104638 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104638 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747530,160792,103440,186683,443397,309185,459598,974493,795077,272965,730245,323580,405605,995122,796153,998141,907035,1025456,761660,1037996,983413,267873,325090,895060,174090,348674,865502,537340,446681,494762,522830,969119,425372,100690,597009,149481,719849,763911,581285,970547,770374,816163,751634,358355,259338,400557,493031,908453,782959,832009,583104,1006790,43890,756868,267046,941810,984914,851364,939117,202183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]