SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430017 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430017 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838013,710315,913723,214247,848926,993829,200509,899203,498089,766784,510584,81111,777773,19523,232647,301918,653578,318690,436910,205336,398749,110298,519351,472999,924166,327845,458141,1028836,598281,327442,782843,688144,243303,187905,584577,591832,828498,122687,55574,147661,768130,779929,419263,317401,794874,1031066,140065,346663,272043,638109,410306,92274,252400,170783,845965,488698,1012406,816215,625893,522079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]