SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671183 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671183 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762693,613504,921795,613548,307981,136654,846755,598880,710290,640383,856346,537372,181599,103056,352430,782283,405923,345972,538088,587673,182950,687823,796905,322274,866168,48237,851495,600730,964058,470741,630773,789269,975603,504331,753485,130588,11828,503354,755217,233271,164142,573770,207429,216177,333911,4288,94292,151705,743571,12621,368047,113625,614765,758866,922645,387000,339077,933949,803574,337059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]