SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 995328 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 995328 [ RunTime:0.007243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740813,913895,544950,1030874,871786,1009152,913587,208046,152246,1005471,704533,615377,255568,207797,572999,577845,37604,478260,797328,864132,390987,208679,347434,894687,654213,187214,642558,866236,957568,33752,164285,114181,247388,898414,592392,217097,745457,95517,172747,642064,18080,65783,109896,143195,19223,947430,881315,203399,755810,953738,84683,252432,18817,645352,808969,792446,583639,30490,475481,120262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 995328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 995328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]