SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536983 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536983 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222616,1007205,577082,889802,407154,394895,448537,764359,929562,690148,586926,119062,823245,181074,635111,184429,361096,111068,577779,7936,603961,29250,982067,978913,620444,1024360,323734,280575,635520,574244,855109,692295,1030399,474280,633506,1034038,327086,78983,178250,620634,782166,521083,226908,833476,222244,627620,178483,114958,361988,728132,462277,872650,225133,471803,151612,182856,925089,12380,638974,98449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]