SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006570 LIMIT 1 [ RunTime:0.003038s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006570 [ RunTime:0.003539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427091,240330,351947,908278,243771,789294,875271,72142,546724,797693,76432,870412,691318,170435,661066,863326,189493,954616,1009827,761385,69296,522165,209680,863425,977199,109018,381099,403311,1012310,254549,518056,790405,636249,637087,101000,182674,962108,432604,999679,728611,796783,766134,214461,23101,573152,503705,165540,897184,292701,816488,779655,109475,160311,870523,58394,921087,34190,938059,944317,630845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001215s ]