SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535214 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535214 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672492,96121,333716,371318,878254,8494,848571,164295,609304,108629,59031,865975,469145,980504,73483,42528,322618,672503,566823,806805,790732,152774,449410,1005362,217799,949977,632411,468918,741652,263189,131968,259647,1017575,438030,857004,487133,1024372,622258,849808,359820,224156,281282,419671,292367,331950,756107,701841,992933,231247,1001624,986346,765658,813942,383827,766242,742838,356774,1047628,351997,723013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]