SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432295 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432295 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023389,305442,201732,600212,173456,293036,34370,26663,721515,50744,329813,637111,753928,238257,220071,444005,634732,789608,1025198,995075,363865,676176,909600,504933,189432,605811,563264,16804,727801,534537,677272,969290,980111,84558,328209,311155,956582,87428,784045,99142,156353,742394,628510,753205,880242,428383,381912,298082,694009,760134,755523,799927,668364,296733,821147,1032301,600571,364536,236225,741433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432295 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432295 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]