SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020711 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020711 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257853,405674,848438,971547,184739,996098,606252,428842,880362,737706,320064,446463,122292,165199,158019,116363,637779,863162,146260,322117,146590,654018,66035,154018,558736,830096,316371,1018256,28726,613489,378583,513457,25483,719968,302374,59689,157040,28468,363623,898863,639109,210106,437290,285800,905818,527505,952487,697523,89454,795399,74294,241243,907553,129987,54189,912419,390410,900701,394255,39515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]