SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415971 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415971 [ RunTime:0.001398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216345,161264,634661,987443,5624,719080,494801,790469,313449,81082,562962,263398,243623,758100,998739,619599,113139,15132,923905,958792,565443,19440,980202,725500,939142,509500,197845,765831,724258,972364,199162,558103,283121,402225,901921,758636,451290,908942,837376,898081,72668,436149,505542,520989,566603,444848,209763,638549,105854,974631,804930,333292,288775,872368,87756,619568,416212,56224,818062,326295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002438s ]