SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336791 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336791 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925076,648161,368098,703896,359999,609065,306760,772803,331908,1019577,906889,394756,935339,998848,430055,557961,685909,281384,746160,127319,882958,894196,861695,786616,867052,416354,494641,556453,993623,510412,477827,360080,195153,6216,590995,483767,774371,308750,231773,690455,352708,108714,535887,805293,175879,818335,797200,659388,89324,779644,696925,230545,174251,906708,227329,530927,170185,146161,461015,901667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]