SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 877509 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 877509 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030169,428665,223812,926273,36963,472203,831688,833302,1009543,179418,635678,489697,312453,848829,713969,238192,1002307,311616,841383,16780,54677,739699,1027596,182651,309668,604626,950670,1024861,209617,345423,361153,833961,295083,264279,104829,16019,977134,823536,200312,371185,156443,975260,822614,928217,308933,1020675,447984,991797,999777,284998,273557,724223,72000,584449,340246,255647,466630,781553,876983,605842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 877509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 877509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]