SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 169413 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 169413 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218188,589202,811513,465296,219135,492659,106590,69662,1001479,375278,1019388,21406,593280,332293,900174,62198,322827,787129,485889,816763,181206,570678,759557,294705,679655,447144,810201,491584,390101,653760,1004925,980881,262191,280436,607808,746615,893552,20155,340204,672970,713912,59531,423275,956123,18657,165536,105083,529694,913240,826649,531427,811501,847295,735276,458826,774118,27661,698710,981107,938353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 169413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 169413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]