SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429479 LIMIT 1 [ RunTime:0.001070s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429479 [ RunTime:0.004723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753662,125891,125952,1005928,559394,140855,58936,170542,203308,917383,779957,373252,701732,709645,703138,740536,854472,593243,155191,879612,777642,846753,300721,163487,742049,393865,821804,1017000,763083,187252,156059,427442,270956,313506,23359,63380,407309,1042513,318147,725694,114744,67041,523105,405408,800727,705871,873611,340756,323137,138966,932696,1021703,808786,897476,182501,207023,150226,166788,801885,263809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]