SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562498 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562498 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545845,974618,797411,272336,453793,541306,717809,896154,651497,674446,347786,569059,407224,359115,1038061,975861,60901,30531,163562,528589,408126,589479,9783,858073,652152,703270,519518,397842,301186,813204,521445,610961,540735,995961,438140,977931,970355,1037004,776444,497257,130065,833606,744043,975405,872153,375704,867175,443140,570150,956313,440622,1014500,693410,517229,253276,811173,824891,170393,1000387,618893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]