SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109134 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109134 [ RunTime:0.002540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029464,30506,791339,53617,856246,807198,737137,1043420,180964,410322,874361,924146,1000011,569641,93088,825684,23312,953175,900659,318159,121301,381811,400996,166039,283211,305737,732941,533571,683364,959104,1044215,167858,58858,30029,945876,458650,310101,417062,470663,662919,916811,734629,498346,25884,721137,859898,238741,665842,968501,105230,1004052,937631,70390,11987,620894,532573,80072,377499,940435,963588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]