SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39811 LIMIT 1 [ RunTime:0.000678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39811 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732647,498084,222865,873663,503524,541588,834926,265137,838001,642052,926941,324045,826552,303253,265701,1009074,399138,936325,202976,136999,201224,69428,693326,287253,943797,349046,444795,566403,830746,409400,700596,529700,41779,79087,634871,217406,1026059,541855,493812,273715,463569,709025,733808,134808,601966,805007,563718,413422,702617,1026626,748346,368045,229602,198654,359327,39039,290577,224072,83954,572827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]