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` = 499541 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499541 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249564,342595,161810,424316,851288,20007,876355,212746,906101,224773,710084,458181,403055,400935,72481,115291,244054,282943,467604,286190,339136,475411,316227,507272,576496,800879,972671,172553,362747,921201,389154,485070,552518,644803,295294,798483,411905,202071,589591,642347,125709,756066,405907,249311,310235,368349,125762,406729,68561,922728,833297,780510,605074,742044,237800,68310,432736,609483,173524,422766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001245s ]