SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047743 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047743 [ RunTime:0.002188s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834054,220527,412350,681743,15729,228514,808096,5100,794329,831242,648184,257593,423819,692611,10511,105245,843300,867136,95196,932277,739805,331643,849565,996752,763494,170784,264887,757802,386439,557289,900631,828774,898322,23977,938451,977396,640314,758137,874124,255124,781552,677875,37210,348762,318740,759313,300590,764493,604468,805724,1007995,215220,906072,133965,746628,843464,400651,568975,819961,425534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]