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` = 417580 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417580 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323228,208080,788273,1023862,82591,1046486,412007,363332,877002,738142,646227,150431,863903,372878,97431,702098,1042337,968195,1032807,59819,825076,24396,1040398,135784,902194,909348,451831,110659,538831,903974,1021919,207402,242988,661608,764374,231660,488141,573440,82049,935810,856259,558195,126547,705223,45171,536590,940632,199860,866171,292519,1046715,357340,1012685,555192,703442,316445,172994,79247,149749,929297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003705s ]