SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020550 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020550 [ RunTime:0.003102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140559,798444,567769,681389,983165,543829,762127,816850,357871,629750,512822,103529,720449,1012063,1063,545759,624959,880409,537752,344811,641053,851548,610511,935559,314656,756862,283071,905696,735667,397030,696015,516314,167664,797217,960982,68967,343207,301064,116686,448053,319687,302067,821975,393251,830675,437306,267674,725944,317879,15299,361923,212570,1048399,618980,626487,117539,154824,463715,625376,63103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]