SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467267 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467267 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811443,847068,481116,957571,100363,1031820,588611,1028447,806297,518163,176810,486669,33770,881878,285325,206734,554126,715276,119336,964072,405713,428582,420547,853155,325328,799277,1024843,603358,383634,95277,833427,320962,251426,112772,793801,3620,988582,533498,364101,77461,752501,373087,398414,821052,259391,363153,638646,665322,832660,315647,945869,276973,689848,513043,717181,748390,29486,88148,125820,1010992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]