SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545009 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545009 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252392,263842,492703,911215,341028,82332,988225,94786,577818,250897,519174,428603,975705,667021,739374,190318,406111,1032394,348290,589798,399950,389388,19157,76196,802301,860086,960728,338926,951717,726720,623855,101067,590570,842081,127694,363977,638516,23652,170602,858057,599173,705147,1037329,1000856,848024,48800,567034,343472,914039,31186,17325,708874,1009178,256555,509328,492327,1026453,649982,86341,818461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001853s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]