SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043867 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043867 [ RunTime:0.006373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318466,763180,251481,657471,699735,210675,659833,9860,54582,352092,170851,646440,294764,542670,189594,504987,760459,840958,33983,845174,301703,621012,892450,791084,282239,713793,325525,624954,197262,1042326,339557,902256,897173,761861,57382,495912,777961,1012717,584391,512501,749453,1008324,1001496,782738,229380,791021,556004,376155,246649,955156,615776,342729,625820,266045,276910,881353,830521,126570,675655,252666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043867 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043867 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]