SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414064 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414064 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33088,206340,456916,226506,434193,56233,711311,835018,344924,884601,24855,326138,853017,50336,174229,440480,442104,156049,506442,642540,500692,398119,854521,338468,522523,109750,33492,499514,869161,357188,931183,326575,352096,360638,108520,47045,38575,795099,918635,939774,183115,1038630,1035321,448152,1034404,317814,620074,994749,941639,485991,35167,612837,373735,185133,692605,905952,121960,779472,314164,196693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]