SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416084 LIMIT 1 [ RunTime:0.000569s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416084 [ RunTime:0.002796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494080,912623,128125,336998,934102,361662,754526,383015,872197,1014881,317214,5151,622148,168716,256183,488642,739719,991166,551194,374980,827317,912206,855173,529830,270648,851677,109025,194362,966037,115938,308962,118699,71349,540739,718077,161131,785516,368749,606320,175790,809912,688676,783327,96083,717355,295786,298804,826779,573655,792084,421837,60482,139617,1032219,651378,146571,737461,573160,70784,639882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]