SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041912 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041912 [ RunTime:0.003145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395871,404521,898768,353264,100315,419601,145351,367052,865893,901959,460622,616712,280281,425155,883696,88085,70073,339383,60118,944656,368856,988635,296931,344136,897470,217205,357609,240937,705020,60804,710348,516533,569227,269361,500956,178872,622543,407180,252997,210678,153943,647239,415764,565688,920090,896295,229427,68000,618444,883206,627385,42156,754250,566026,368788,78705,251613,518698,831429,947591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]