SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003984 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003984 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303563,425047,796215,876085,990010,144165,968706,852697,98547,818905,994481,1011761,589906,1022918,589750,85982,145256,552842,531576,529299,962156,644743,146690,191018,671661,325770,41834,343191,970791,568850,891747,884704,100265,645248,762566,935473,76425,177784,572638,625550,131771,68357,676186,392232,218278,412331,650555,256525,543482,384255,201313,1045799,514805,791277,645537,440187,420430,759198,500146,769625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]