SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589501 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589501 [ RunTime:0.004543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726347,254311,156753,859054,645924,525420,982414,877227,15609,222784,450082,822507,1028379,536274,926933,200588,781614,683242,667326,55713,289237,195481,1152,891802,260287,55637,979794,229630,346420,814917,282726,718454,520039,215123,552152,160070,223647,107407,303675,347624,259893,934994,800595,121115,710572,131864,508200,529023,356337,168791,526944,426322,23630,862444,637086,700321,579469,707094,559296,923445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]