SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415975 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415975 [ RunTime:0.002262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027664,302057,875066,332893,515379,889023,244181,193505,536092,689461,432410,21371,836307,1005139,35597,272292,456464,440273,1926,111200,650563,643581,1042799,219554,433257,509925,274883,720770,441555,896761,807980,743260,520200,341653,439890,28041,235619,777766,294586,86378,690206,1024125,213269,854326,939739,800560,1044983,671000,827217,370234,369637,417814,754886,629354,703086,113137,383834,51240,99070,394645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]