SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 16412 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 16412 [ RunTime:0.002892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41670,349467,269720,554004,839804,26464,600624,295166,441410,907066,544905,391221,201330,258595,900590,101504,542323,141107,236785,200557,375188,121746,568954,271727,967599,609544,169077,772390,813767,278377,298896,468523,692274,853956,333649,700956,841993,957464,112910,178437,70526,1010319,561888,11965,40189,583890,293375,857901,895880,246636,300097,200112,260763,638716,751659,411581,482437,952961,205885,715071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 16412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 16412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]