SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407729 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407729 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286297,164964,659072,426517,914251,13549,840567,34566,1042095,968297,188451,621214,449112,324291,258419,435960,590703,496567,94079,736427,6798,573366,115057,188287,696356,463890,241460,857051,877030,420368,728648,989443,1027501,529212,51775,85163,667186,132543,117042,33209,142694,945779,606320,1037818,235300,519243,885297,379294,676898,167816,296905,339697,177383,576270,328483,341636,349970,1044518,445274,411052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]