SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261640 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261640 [ RunTime:0.001404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376039,230835,100319,250788,360412,732435,462136,130878,420446,851014,139712,981164,590711,37811,792805,662012,53557,589307,977375,346810,456614,712462,729070,806394,33846,660936,525473,226383,154137,245335,430994,605660,293476,587600,1048236,404632,112030,362106,509535,318816,569469,361363,235519,39694,309068,44791,367607,777554,759466,700792,587339,194220,496558,86411,953955,653470,161800,995465,830412,569144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]