SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101941 LIMIT 1 [ RunTime:0.000740s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101941 [ RunTime:0.002189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677614,329211,779184,972973,109583,126317,346788,1028622,462225,944538,113912,465129,499630,585596,655189,968693,327203,973799,607304,828224,52020,715403,867791,860069,79738,817876,117522,865826,872417,1045569,61960,779466,22071,211723,154459,164833,216807,772337,620916,1020745,759722,593710,731539,726826,227004,683486,646553,965852,759804,559479,74758,923305,480759,1010375,899930,529940,606073,322420,138715,487592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000869s ]