SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442083 LIMIT 1 [ RunTime:0.000882s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442083 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643305,714614,272570,460466,102815,94416,657921,529341,165873,49353,506808,515407,681576,453868,476569,69401,914184,1036140,244566,681678,372737,692527,792317,277942,982160,460602,461496,265028,669949,20057,252057,1028557,700464,955521,571935,101817,445098,226141,677817,551724,701214,70746,479756,231386,1026752,824920,393391,524943,152799,359281,883687,400201,748453,80287,601113,37172,935534,301810,63303,959397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]