SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514680 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514680 [ RunTime:0.003141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582678,14854,689166,635651,435417,503862,16168,877640,515555,423258,605217,1029118,565613,537432,101313,1022371,293336,161901,828700,447026,362530,286077,525379,863036,524761,299247,134357,438026,475639,463658,713317,195773,552037,324987,692341,634740,546616,353698,256258,396429,1011141,466308,560908,528710,979583,481530,301784,771801,999761,950098,715707,129347,208413,641351,777577,101378,649721,755210,247568,789641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]